﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="V_SerialNoListDataSet" targetNamespace="http://tempuri.org/V_SerialNoListDataSet.xsd" xmlns:mstns="http://tempuri.org/V_SerialNoListDataSet.xsd" xmlns="http://tempuri.org/V_SerialNoListDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DataSetFile="V_SerialNoListDataSet.Dataset.Designer.cs" DataSetProject="MobilePlatform.DomainModel" DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="ConnectionString (Settings)" ParameterPrefix=":" PropertyReference="ApplicationSettings.Asd.MP.Data.Properties.Settings.GlobalReference.Default.ConnectionString" Provider="Oracle.DataAccess.Client" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="V_SERIALNOLISTTableAdapter" GeneratorDataComponentClassName="V_SERIALNOLISTTableAdapter" Name="V_SERIALNOLIST" UserDataComponentName="V_SERIALNOLISTTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="MP.V_SERIALNOLIST" DbObjectType="View" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT SN, EMPACCOUNT, MOBILE, STATUS, REMARK, IMEI, MOBILEMODEL, PLATFORM, PLATFORMVERSION, FIRSTLOGINTIME, LASTLOGINTIME FROM MP.V_SERIALNOLIST</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="SN" DataSetColumn="SN" />
              <Mapping SourceColumn="EMPACCOUNT" DataSetColumn="EMPACCOUNT" />
              <Mapping SourceColumn="MOBILE" DataSetColumn="MOBILE" />
              <Mapping SourceColumn="STATUS" DataSetColumn="STATUS" />
              <Mapping SourceColumn="REMARK" DataSetColumn="REMARK" />
              <Mapping SourceColumn="IMEI" DataSetColumn="IMEI" />
              <Mapping SourceColumn="MOBILEMODEL" DataSetColumn="MOBILEMODEL" />
              <Mapping SourceColumn="PLATFORM" DataSetColumn="PLATFORM" />
              <Mapping SourceColumn="PLATFORMVERSION" DataSetColumn="PLATFORMVERSION" />
              <Mapping SourceColumn="FIRSTLOGINTIME" DataSetColumn="FIRSTLOGINTIME" />
              <Mapping SourceColumn="LASTLOGINTIME" DataSetColumn="LASTLOGINTIME" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="MP.V_SERIALNOLIST" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillBy" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillBy" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillBy">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   SN, EMPACCOUNT, MOBILE, STATUS, REMARK, IMEI, MOBILEMODEL, PLATFORM, PLATFORMVERSION, 
                FIRSTLOGINTIME, LASTLOGINTIME
FROM      V_SERIALNOLIST
WHERE   (SN = :PARAM1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="PARAM1" ColumnName="SN" DataSourceName="MP.V_SERIALNOLIST" DataTypeServer="CHAR(36)" DbType="String" Direction="Input" ParameterName=":PARAM1" Precision="0" ProviderType="Char" Scale="0" Size="36" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="MP.V_SERIALNOLIST" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByAccount" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByAccount" GeneratorSourceName="FillByAccount" GetMethodModifier="Public" GetMethodName="GetDataByAccount" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByAccount" UserSourceName="FillByAccount">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   SN, EMPACCOUNT, MOBILE, STATUS, REMARK, IMEI, MOBILEMODEL, PLATFORM, PLATFORMVERSION, 
                FIRSTLOGINTIME, LASTLOGINTIME
FROM      V_SERIALNOLIST
WHERE   (EMPACCOUNT = :PARAM1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PARAM1" ColumnName="EMPACCOUNT" DataSourceName="MP.V_SERIALNOLIST" DataTypeServer="NVARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PARAM1" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="EMPACCOUNT" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="ConnectionString (Settings)" DbObjectName="MP.V_SERIALNOLIST" DbObjectType="View" FillMethodModifier="Public" FillMethodName="FillByMobile" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByMobile" GeneratorSourceName="FillByMobile" GetMethodModifier="Public" GetMethodName="GetDataByMobile" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByMobile" UserSourceName="FillByMobile">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT   SN, EMPACCOUNT, MOBILE, STATUS, REMARK, IMEI, MOBILEMODEL, PLATFORM, PLATFORMVERSION, 
                FIRSTLOGINTIME, LASTLOGINTIME
FROM      V_SERIALNOLIST
WHERE   (MOBILE = :PARAM1)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="PARAM1" ColumnName="MOBILE" DataSourceName="MP.V_SERIALNOLIST" DataTypeServer="NVARCHAR2(20)" DbType="String" Direction="Input" ParameterName=":PARAM1" Precision="0" ProviderType="Varchar2" Scale="0" Size="20" SourceColumn="MOBILE" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="V_SerialNoListDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="V_SerialNoListDataSet" msprop:Generator_UserDSName="V_SerialNoListDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="V_SERIALNOLIST" msprop:Generator_TableClassName="V_SERIALNOLISTDataTable" msprop:Generator_TableVarName="tableV_SERIALNOLIST" msprop:Generator_TablePropName="V_SERIALNOLIST" msprop:Generator_RowDeletingName="V_SERIALNOLISTRowDeleting" msprop:Generator_UserTableName="V_SERIALNOLIST" msprop:Generator_RowChangingName="V_SERIALNOLISTRowChanging" msprop:Generator_RowEvHandlerName="V_SERIALNOLISTRowChangeEventHandler" msprop:Generator_RowDeletedName="V_SERIALNOLISTRowDeleted" msprop:Generator_RowEvArgName="V_SERIALNOLISTRowChangeEvent" msprop:Generator_RowChangedName="V_SERIALNOLISTRowChanged" msprop:Generator_RowClassName="V_SERIALNOLISTRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SN" msprop:Generator_ColumnVarNameInTable="columnSN" msprop:Generator_ColumnPropNameInRow="SN" msprop:Generator_ColumnPropNameInTable="SNColumn" msprop:Generator_UserColumnName="SN">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="36" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EMPACCOUNT" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="EMPACCOUNT" msprop:Generator_ColumnVarNameInTable="columnEMPACCOUNT" msprop:Generator_ColumnPropNameInTable="EMPACCOUNTColumn" msprop:Generator_UserColumnName="EMPACCOUNT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MOBILE" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="MOBILE" msprop:Generator_ColumnVarNameInTable="columnMOBILE" msprop:Generator_ColumnPropNameInTable="MOBILEColumn" msprop:Generator_UserColumnName="MOBILE" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="STATUS" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="STATUS" msprop:Generator_ColumnVarNameInTable="columnSTATUS" msprop:Generator_ColumnPropNameInTable="STATUSColumn" msprop:Generator_UserColumnName="STATUS" type="xs:decimal" />
              <xs:element name="REMARK" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="REMARK" msprop:Generator_ColumnVarNameInTable="columnREMARK" msprop:Generator_ColumnPropNameInTable="REMARKColumn" msprop:Generator_UserColumnName="REMARK" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2000" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IMEI" msprop:nullValue="0" msprop:Generator_ColumnPropNameInRow="IMEI" msprop:Generator_ColumnVarNameInTable="columnIMEI" msprop:Generator_ColumnPropNameInTable="IMEIColumn" msprop:Generator_UserColumnName="IMEI" type="xs:long" minOccurs="0" />
              <xs:element name="MOBILEMODEL" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="MOBILEMODEL" msprop:Generator_ColumnVarNameInTable="columnMOBILEMODEL" msprop:Generator_ColumnPropNameInTable="MOBILEMODELColumn" msprop:Generator_UserColumnName="MOBILEMODEL" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PLATFORM" msdata:ReadOnly="true" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="PLATFORM" msprop:Generator_ColumnVarNameInTable="columnPLATFORM" msprop:Generator_ColumnPropNameInTable="PLATFORMColumn" msprop:Generator_UserColumnName="PLATFORM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PLATFORMVERSION" msprop:nullValue="_empty" msprop:Generator_ColumnPropNameInRow="PLATFORMVERSION" msprop:Generator_ColumnVarNameInTable="columnPLATFORMVERSION" msprop:Generator_ColumnPropNameInTable="PLATFORMVERSIONColumn" msprop:Generator_UserColumnName="PLATFORMVERSION" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FIRSTLOGINTIME" msprop:nullValue="_throw" msprop:Generator_ColumnPropNameInRow="FIRSTLOGINTIME" msprop:Generator_ColumnVarNameInTable="columnFIRSTLOGINTIME" msprop:Generator_ColumnPropNameInTable="FIRSTLOGINTIMEColumn" msprop:Generator_UserColumnName="FIRSTLOGINTIME" type="xs:dateTime" minOccurs="0" />
              <xs:element name="LASTLOGINTIME" msprop:nullValue="_throw" msprop:Generator_ColumnPropNameInRow="LASTLOGINTIME" msprop:Generator_ColumnVarNameInTable="columnLASTLOGINTIME" msprop:Generator_ColumnPropNameInTable="LASTLOGINTIMEColumn" msprop:Generator_UserColumnName="LASTLOGINTIME" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
  </xs:element>
</xs:schema>